Skip to main content

SwyxWare - DSN connection

These instructions help you configure your SwyxWare phone system to work with TIM Enterprise. Contact your system maintainer if you are not familiar with the configuration of your PBX.

Support files​

Ensure the following support files exist in the /config/ folder of the TIM Enterprise application:

Swyx V8.TDT
Swyx V8.TDS
Swyx V8.DBS

Contents​

Configure the SMDR output​

info

You may need to purchase a license to enable SMDR on this PBX. Please speak to your system maintainer if you are unsure.

Follow the instructions below to configure the SMDR output. These instructions are taken from the SwyxWare manual:

By default, the Swyx telephone system writes its CDR data to a MSSQL database. In order for TIM Enterprise to connect to the database and collect the call logging data, you need to create a username and password in the MSSQL database on the Swyx server. Contact your system maintainer if you are not familiar with this procedure.

The following information is required for TIM Enterprise to connect to the Swyx database:

  • IP address or hostname of the Swyx server where the MSSQL database resides.
  • Username and Password of the Swyx database.

The default credentials for the Swyx database are shown below:

  • Username: Swyxcdr
  • Password: Swyxcdr

Configure the DSN connection​

To enable TIM Enterprise to work with your Skype for Business phone system, you first need to set up a DSN connection by following the steps below:

  1. Open Windows Control Panel and select the Administrative Tools icon

  2. Double-click on the Data Sources (ODBC) icon to open the ODBC Data Source Administrator window.

info

For a 64 bit system, access the ODBC Data Source Administrator from the following location C:\Windows\SysWOW64\odbcad32.exe

  1. Click on the System DSN tab.

  2. Click on the Add button.

  3. Select SQL Native Client from the driver list and click Finish.

  4. In the Name field, enter swyx.

  5. In the Description field, enter TIM Enterprise link to swyx.

  6. In the Server field, enter the IP address or hostname of your Swyx server.

  7. In the Username field, enter the username for your Swyx database.

  8. In the Password field, enter the password for your Swyx database.

  9. In the Database drop-down list, select swyx.

  10. Click on the Test button to confirm the information you entered is correct and that the connection is successful.

  11. Click on the OK button to close the window.

odbc connection

Configure TIM Enterprise​

Once NetPBX is configured and collecting data, log in to TIM Enterprise and perform the following steps:

  1. Click on the Directory tab.

  2. If you don't have a PBX object, press New object and select PBX. Name your site and then select Add. Locate the PBX object you want to configure in the Directory, click on it and select Properties.

  3. A new window will open, displaying the general properties of your PBX object. Select Swyx V8 from the Data format list as shown below:

    TIM Enterprise PBX General Properties

  4. Click on the Connection tab and select System DSN connection from the Connection method list.

    TIM Enterprise PBX Connection Properties

  5. In the DSN field, select swyx from the drop-down list.

  6. In the Frequency field, enter 5 to check for data every five seconds.

  7. In the DB script field, select SWYX V8 from the drop-down list.

  8. Click on the Save button to apply the settings.